<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<meta name="robots" content="noindex">

	<title>File Home/Model/SkuBillModel.class.php | XY Server API alpha</title>

	<link rel="stylesheet" href="resources/style.css?e99947befd7bf673c6b43ff75e9e0f170c88a60e">

</head>

<body>
<div id="left">
	<div id="menu">
		<a href="index.html" title="Overview"><span>Overview</span></a>


		<div id="groups">
				<h3>Namespaces</h3>
			<ul>
				<li>
					<a href="namespace-Behavior.html">
						Behavior					</a>

						</li>
				<li>
					<a href="namespace-DatebaseSQL.html">
						DatebaseSQL					</a>

						</li>
				<li>
					<a href="namespace-Doc.html">
						Doc					</a>

						</li>
				<li>
					<a href="namespace-ErrorCode.html">
						ErrorCode					</a>

						</li>
				<li>
					<a href="namespace-Home.html">
						Home<span></span>
					</a>

						<ul>
				<li>
					<a href="namespace-Home.Controller.html">
						Controller					</a>

						</li>
				<li>
					<a href="namespace-Home.Model.html">
						Model					</a>

						</li>
							</ul></li>
				<li>
					<a href="namespace-None.html">
						None					</a>

						</li>
				<li>
					<a href="namespace-Think.html">
						Think					</a>

						</li>
			</ul>
		</div>

		<hr>


		<div id="elements">
			<h3>Classes</h3>
			<ul>
				<li><a href="class-AccountModelTest.html">AccountModelTest</a></li>
				<li><a href="class-BaseTest.html">BaseTest</a></li>
				<li><a href="class-Behavior.BuildLiteBehavior.html">Behavior\BuildLiteBehavior</a></li>
				<li><a href="class-Behavior.ContentReplaceBehavior.html">Behavior\ContentReplaceBehavior</a></li>
				<li><a href="class-Behavior.ParseTemplateBehavior.html">Behavior\ParseTemplateBehavior</a></li>
				<li><a href="class-ErrorCode.ErrorCode.html">ErrorCode\ErrorCode</a></li>
				<li><a href="class-Home.Controller.AccountController.html">Home\Controller\AccountController</a></li>
				<li><a href="class-Home.Controller.ApplyController.html">Home\Controller\ApplyController</a></li>
				<li><a href="class-Home.Controller.AuthController.html">Home\Controller\AuthController</a></li>
				<li><a href="class-Home.Controller.BaseController.html">Home\Controller\BaseController</a></li>
				<li><a href="class-Home.Controller.CarlicenseController.html">Home\Controller\CarlicenseController</a></li>
				<li><a href="class-Home.Controller.CompanyController.html">Home\Controller\CompanyController</a></li>
				<li><a href="class-Home.Controller.ConfigController.html">Home\Controller\ConfigController</a></li>
				<li><a href="class-Home.Controller.ContactController.html">Home\Controller\ContactController</a></li>
				<li><a href="class-Home.Controller.CusListController.html">Home\Controller\CusListController</a></li>
				<li><a href="class-Home.Controller.DepartmentController.html">Home\Controller\DepartmentController</a></li>
				<li><a href="class-Home.Controller.EmptyController.html">Home\Controller\EmptyController</a></li>
				<li><a href="class-Home.Controller.EverydaySummarySheetController.html">Home\Controller\EverydaySummarySheetController</a></li>
				<li><a href="class-Home.Controller.FaceRecController.html">Home\Controller\FaceRecController</a></li>
				<li><a href="class-Home.Controller.FeedbackController.html">Home\Controller\FeedbackController</a></li>
				<li><a href="class-Home.Controller.FinanceController.html">Home\Controller\FinanceController</a></li>
				<li><a href="class-Home.Controller.GeneratorController.html">Home\Controller\GeneratorController</a></li>
				<li><a href="class-Home.Controller.GoodController.html">Home\Controller\GoodController</a></li>
				<li><a href="class-Home.Controller.HomeController.html">Home\Controller\HomeController</a></li>
				<li><a href="class-Home.Controller.IndexController.html" class="invalid">Home\Controller\IndexController</a></li>
				<li><a href="class-Home.Controller.InstallController.html">Home\Controller\InstallController</a></li>
				<li><a href="class-Home.Controller.LoginController.html">Home\Controller\LoginController</a></li>
				<li><a href="class-Home.Controller.OrderController.html">Home\Controller\OrderController</a></li>
				<li><a href="class-Home.Controller.OtherController.html">Home\Controller\OtherController</a></li>
				<li><a href="class-Home.Controller.ParkaddressController.html">Home\Controller\ParkaddressController</a></li>
				<li><a href="class-Home.Controller.PaybillController.html">Home\Controller\PaybillController</a></li>
				<li><a href="class-Home.Controller.PaymentDetailsController.html">Home\Controller\PaymentDetailsController</a></li>
				<li><a href="class-Home.Controller.PhonenumController.html">Home\Controller\PhonenumController</a></li>
				<li><a href="class-Home.Controller.PrintTemplateController.html">Home\Controller\PrintTemplateController</a></li>
				<li><a href="class-Home.Controller.QnUploadController.html">Home\Controller\QnUploadController</a></li>
				<li><a href="class-Home.Controller.QueryController.html">Home\Controller\QueryController</a></li>
				<li><a href="class-Home.Controller.RealDataGeneratorController.html">Home\Controller\RealDataGeneratorController</a></li>
				<li><a href="class-Home.Controller.SkuStorageController.html">Home\Controller\SkuStorageController</a></li>
				<li><a href="class-Home.Controller.SmsDetailsController.html">Home\Controller\SmsDetailsController</a></li>
				<li><a href="class-Home.Controller.StatementOfAccountController.html">Home\Controller\StatementOfAccountController</a></li>
				<li><a href="class-Home.Controller.StorageController.html">Home\Controller\StorageController</a></li>
				<li><a href="class-Home.Controller.UpdateController.html">Home\Controller\UpdateController</a></li>
				<li><a href="class-Home.Controller.UpdateDatabaseFormatController.html">Home\Controller\UpdateDatabaseFormatController</a></li>
				<li><a href="class-Home.Controller.UserAccountController.html">Home\Controller\UserAccountController</a></li>
				<li><a href="class-Home.Controller.UserController.html">Home\Controller\UserController</a></li>
				<li><a href="class-Home.Controller.UtilController.html">Home\Controller\UtilController</a></li>
				<li><a href="class-Home.Controller.WarehouseController.html">Home\Controller\WarehouseController</a></li>
				<li><a href="class-Home.Model.AccountModel.html">Home\Model\AccountModel</a></li>
				<li><a href="class-Home.Model.ApplyModel.html">Home\Model\ApplyModel</a></li>
				<li><a href="class-Home.Model.AsynTasksModel.html">Home\Model\AsynTasksModel</a></li>
				<li><a href="class-Home.Model.AuthGroupAccessModel.html">Home\Model\AuthGroupAccessModel</a></li>
				<li><a href="class-Home.Model.AuthGroupModel.html">Home\Model\AuthGroupModel</a></li>
				<li><a href="class-Home.Model.AuthRuleModel.html">Home\Model\AuthRuleModel</a></li>
				<li><a href="class-Home.Model.BaseadvModel.html">Home\Model\BaseadvModel</a></li>
				<li><a href="class-Home.Model.CarlicenseModel.html">Home\Model\CarlicenseModel</a></li>
				<li><a href="class-Home.Model.CatModel.html">Home\Model\CatModel</a></li>
				<li><a href="class-Home.Model.CompanyModel.html">Home\Model\CompanyModel</a></li>
				<li><a href="class-Home.Model.ConfigModel.html">Home\Model\ConfigModel</a></li>
				<li><a href="class-Home.Model.ContactModel.html">Home\Model\ContactModel</a></li>
				<li><a href="class-Home.Model.CusListModel.html">Home\Model\CusListModel</a></li>
				<li><a href="class-Home.Model.DepartmentModel.html">Home\Model\DepartmentModel</a></li>
				<li><a href="class-Home.Model.EverydaySummarySheetModel.html">Home\Model\EverydaySummarySheetModel</a></li>
				<li><a href="class-Home.Model.FaceRecModel.html">Home\Model\FaceRecModel</a></li>
				<li><a href="class-Home.Model.FeedbackModel.html">Home\Model\FeedbackModel</a></li>
				<li><a href="class-Home.Model.FinanceModel.html">Home\Model\FinanceModel</a></li>
				<li><a href="class-Home.Model.GoodModel.html">Home\Model\GoodModel</a></li>
				<li><a href="class-Home.Model.OrderModel.html">Home\Model\OrderModel</a></li>
				<li><a href="class-Home.Model.OtherModel.html">Home\Model\OtherModel</a></li>
				<li><a href="class-Home.Model.ParkaddressModel.html">Home\Model\ParkaddressModel</a></li>
				<li><a href="class-Home.Model.PaybillModel.html">Home\Model\PaybillModel</a></li>
				<li><a href="class-Home.Model.PaymentDetailsModel.html">Home\Model\PaymentDetailsModel</a></li>
				<li><a href="class-Home.Model.PhonenumModel.html">Home\Model\PhonenumModel</a></li>
				<li><a href="class-Home.Model.PinYin.html">Home\Model\PinYin</a></li>
				<li><a href="class-Home.Model.PrintTemplateModel.html">Home\Model\PrintTemplateModel</a></li>
				<li><a href="class-Home.Model.QnUploadModel.html">Home\Model\QnUploadModel</a></li>
				<li><a href="class-Home.Model.QueryModel.html">Home\Model\QueryModel</a></li>
				<li><a href="class-Home.Model.SkuBillModel.html">Home\Model\SkuBillModel</a></li>
				<li><a href="class-Home.Model.SkuCidPriceModel.html">Home\Model\SkuCidPriceModel</a></li>
				<li><a href="class-Home.Model.SkuModel.html">Home\Model\SkuModel</a></li>
				<li><a href="class-Home.Model.SkuStorageModel.html">Home\Model\SkuStorageModel</a></li>
				<li><a href="class-Home.Model.SmsDetailsModel.html">Home\Model\SmsDetailsModel</a></li>
				<li><a href="class-Home.Model.SpuModel.html">Home\Model\SpuModel</a></li>
				<li><a href="class-Home.Model.StatementAccountModel.html">Home\Model\StatementAccountModel</a></li>
				<li><a href="class-Home.Model.StorageModel.html">Home\Model\StorageModel</a></li>
				<li><a href="class-Home.Model.UpdateDatabaseFormatModel.html">Home\Model\UpdateDatabaseFormatModel</a></li>
				<li><a href="class-Home.Model.UserAccountModel.html">Home\Model\UserAccountModel</a></li>
				<li><a href="class-Home.Model.UserModel.html">Home\Model\UserModel</a></li>
				<li><a href="class-Home.Model.UtilModel.html">Home\Model\UtilModel</a></li>
				<li><a href="class-Home.Model.WarehouseModel.html">Home\Model\WarehouseModel</a></li>
				<li><a href="class-IndexTest.html" class="invalid">IndexTest</a></li>
				<li><a href="class-OrderTest.html">OrderTest</a></li>
				<li><a href="class-SkuTest.html" class="invalid">SkuTest</a></li>
				<li><a href="class-StorageTest.html">StorageTest</a></li>
				<li><a href="class-Think.App.html">Think\App</a></li>
				<li><a href="class-Think.Controller.html">Think\Controller</a></li>
				<li><a href="class-Think.Dispatcher.html">Think\Dispatcher</a></li>
				<li><a href="class-Think.Hook.html">Think\Hook</a></li>
				<li><a href="class-Think.Route.html">Think\Route</a></li>
				<li><a href="class-Think.View.html">Think\View</a></li>
				<li><a href="class-tpunit.html">tpunit</a></li>
				<li><a href="class-WarehouseTest.html">WarehouseTest</a></li>
			</ul>



			<h3>Exceptions</h3>
			<ul>
				<li><a href="class-XYException.html">XYException</a></li>
			</ul>


			<h3>Functions</h3>
			<ul>
				<li><a href="function-A.html">A</a></li>
				<li><a href="function-array_map_recursive.html">array_map_recursive</a></li>
				<li><a href="function-B.html">B</a></li>
				<li><a href="function-C.html">C</a></li>
				<li><a href="function-compile.html">compile</a></li>
				<li><a href="function-controller.html">controller</a></li>
				<li><a href="function-cookie.html">cookie</a></li>
				<li><a href="function-D.html">D</a></li>
				<li><a href="function-data_auth_sign.html">data_auth_sign</a></li>
				<li><a href="function-data_to_xml.html">data_to_xml</a></li>
				<li><a href="function-DatebaseSQL.datebaseSQL.html">DatebaseSQL\datebaseSQL</a></li>
				<li><a href="function-Doc.doc_view.html">Doc\doc_view</a></li>
				<li><a href="function-dump.html">dump</a></li>
				<li><a href="function-E.html">E</a></li>
				<li><a href="function-F.html">F</a></li>
				<li><a href="function-file_exists_case.html">file_exists_case</a></li>
				<li><a href="function-findSubStr.html">findSubStr</a></li>
				<li><a href="function-G.html">G</a></li>
				<li><a href="function-get_client_ip.html">get_client_ip</a></li>
				<li><a href="function-getAdminUid.html">getAdminUid</a></li>
				<li><a href="function-getLenOfDeciNum.html">getLenOfDeciNum</a></li>
				<li><a href="function-getRpg.html">getRpg</a></li>
				<li><a href="function-getUid.html">getUid</a></li>
				<li><a href="function-guid.html">guid</a></li>
				<li><a href="function-I.html">I</a></li>
				<li><a href="function-import.html">import</a></li>
				<li><a href="function-in_array_case.html">in_array_case</a></li>
				<li><a href="function-is_login.html">is_login</a></li>
				<li><a href="function-is_ssl.html">is_ssl</a></li>
				<li><a href="function-isInt.html">isInt</a></li>
				<li><a href="function-isLegalCurrency.html">isLegalCurrency</a></li>
				<li><a href="function-isNonegativeReal.html">isNonegativeReal</a></li>
				<li><a href="function-isNonnegativeInt.html">isNonnegativeInt</a></li>
				<li><a href="function-isPositiveReal.html">isPositiveReal</a></li>
				<li><a href="function-isUnsignedInt.html">isUnsignedInt</a></li>
				<li><a href="function-L.html">L</a></li>
				<li><a href="function-layout.html">layout</a></li>
				<li><a href="function-load.html">load</a></li>
				<li><a href="function-load_config.html">load_config</a></li>
				<li><a href="function-load_ext_file.html">load_ext_file</a></li>
				<li><a href="function-loadConfig.html">loadConfig</a></li>
				<li><a href="function-loadConfig_key.html">loadConfig_key</a></li>
				<li><a href="function-loadConfigFile.html">loadConfigFile</a></li>
				<li><a href="function-loadLocalConfig.html">loadLocalConfig</a></li>
				<li><a href="function-log_.html">log_</a></li>
				<li><a href="function-M.html">M</a></li>
				<li><a href="function-N.html">N</a></li>
				<li><a href="function-parse_name.html">parse_name</a></li>
				<li><a href="function-parse_res_name.html">parse_res_name</a></li>
				<li><a href="function-R.html">R</a></li>
				<li><a href="function-redirect.html">redirect</a></li>
				<li><a href="function-require_cache.html">require_cache</a></li>
				<li><a href="function-S.html">S</a></li>
				<li><a href="function-send_http_status.html">send_http_status</a></li>
				<li><a href="function-session.html">session</a></li>
				<li><a href="function-strip_whitespace.html">strip_whitespace</a></li>
				<li><a href="function-T.html">T</a></li>
				<li><a href="function-tag.html">tag</a></li>
				<li><a href="function-think_filter.html">think_filter</a></li>
				<li><a href="function-think_ucenter_decrypt.html">think_ucenter_decrypt</a></li>
				<li><a href="function-think_ucenter_encrypt.html">think_ucenter_encrypt</a></li>
				<li><a href="function-think_ucenter_md5.html">think_ucenter_md5</a></li>
				<li><a href="function-throw_exception.html">throw_exception</a></li>
				<li><a href="function-to_guid_string.html">to_guid_string</a></li>
				<li><a href="function-trace.html">trace</a></li>
				<li><a href="function-U.html">U</a></li>
				<li><a href="function-vendor.html">vendor</a></li>
				<li><a href="function-W.html">W</a></li>
				<li><a href="function-xml_encode.html">xml_encode</a></li>
				<li><a href="function-xyadd.html">xyadd</a></li>
				<li><a href="function-xycomp.html">xycomp</a></li>
				<li><a href="function-xydiv.html">xydiv</a></li>
				<li><a href="function-xymod.html">xymod</a></li>
				<li><a href="function-xymul.html">xymul</a></li>
				<li><a href="function-xyround.html">xyround</a></li>
				<li><a href="function-xysub.html">xysub</a></li>
				<li><a href="function-yaml_parse_file.html">yaml_parse_file</a></li>
			</ul>
		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
<div id="rightInner">
	<form id="search">
		<input type="hidden" name="cx" value="">
		<input type="hidden" name="ie" value="UTF-8">
		<input type="text" name="q" class="text" placeholder="Search">
	</form>

	<div id="navigation">
		<ul>
			<li>
				<a href="index.html" title="Overview"><span>Overview</span></a>
			</li>
			<li>
<span>Namespace</span>			</li>
			<li>
<span>Class</span>			</li>
		</ul>
		<ul>
			<li>
				<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
			</li>
				<li>
					<a href="annotation-group-api.html" title="List of elements with api annotation">
						<span>Api</span>
					</a>
				</li>
				<li>
					<a href="annotation-group-version.html" title="List of elements with version annotation">
						<span>Version</span>
					</a>
				</li>
				<li>
					<a href="annotation-group-since.html" title="List of elements with since annotation">
						<span>Since</span>
					</a>
				</li>
				<li>
					<a href="annotation-group-deprecated.html" title="List of elements with deprecated annotation">
						<span>Deprecated</span>
					</a>
				</li>
				<li>
					<a href="annotation-group-todo.html" title="List of elements with todo annotation">
						<span>Todo</span>
					</a>
				</li>
		</ul>
		<ul>
		</ul>
	</div>

<pre><code><span id="1" class="l"><a href="#1">  1: </a><span class="xlang">&lt;?php</span>
</span><span id="2" class="l"><a href="#2">  2: </a><span class="php-keyword1">namespace</span> Home\Model;
</span><span id="3" class="l"><a href="#3">  3: </a><span class="php-keyword1">use</span> Think\Model;
</span><span id="4" class="l"><a href="#4">  4: </a>
</span><span id="5" class="l"><a href="#5">  5: </a><span class="php-comment">/**
</span></span><span id="6" class="l"><a href="#6">  6: </a><span class="php-comment"> * sku_单据 关联表.
</span></span><span id="7" class="l"><a href="#7">  7: </a><span class="php-comment"> * 用途：看sku/spu是被哪个单据卖了.
</span></span><span id="8" class="l"><a href="#8">  8: </a><span class="php-comment"> * 
</span></span><span id="9" class="l"><a href="#9">  9: </a><span class="php-comment"> * - 参考文档：{@see \Doc\doc_view()}
</span></span><span id="10" class="l"><a href="#10"> 10: </a><span class="php-comment"> * - 错误代码：{@see \ErrorCode\ErrorCode()}
</span></span><span id="11" class="l"><a href="#11"> 11: </a><span class="php-comment"> */</span>
</span><span id="12" class="l"><a href="#12"> 12: </a><span class="php-keyword1">class</span> SkuBillModel <span class="php-keyword1">extends</span> BaseadvModel
</span><span id="13" class="l"><a href="#13"> 13: </a>{
</span><span id="14" class="l"><a href="#14"> 14: </a>    <span class="php-comment">/* 自动验证 */</span>
</span><span id="15" class="l"><a href="#15"> 15: </a>    <span class="php-keyword1">protected</span> <span class="php-var">$_validate</span> = <span class="php-keyword1">array</span>(
</span><span id="16" class="l"><a href="#16"> 16: </a>        <span class="php-comment">//SkuBillModel_create_</span>
</span><span id="17" class="l"><a href="#17"> 17: </a>        <span class="php-keyword1">array</span>(<span class="php-quote">'sku_id'</span>, <span class="php-quote">'isUnsignedInt'</span>,-<span class="php-num">14002</span>,
</span><span id="18" class="l"><a href="#18"> 18: </a>            self::MUST_VALIDATE, <span class="php-quote">'function'</span>,self::SkuBillModel_create_), <span class="php-comment">//sku_id不合法</span>
</span><span id="19" class="l"><a href="#19"> 19: </a>        <span class="php-keyword1">array</span>(<span class="php-quote">'spu_id'</span>, <span class="php-quote">'isUnsignedInt'</span>,-<span class="php-num">14003</span>,
</span><span id="20" class="l"><a href="#20"> 20: </a>            self::MUST_VALIDATE, <span class="php-quote">'function'</span>,self::SkuBillModel_create_), <span class="php-comment">//spu_id不合法</span>
</span><span id="21" class="l"><a href="#21"> 21: </a>        <span class="php-keyword1">array</span>(<span class="php-quote">'bill_class'</span>, <span class="php-quote">'isUnsignedInt'</span>,-<span class="php-num">14004</span>,
</span><span id="22" class="l"><a href="#22"> 22: </a>            self::MUST_VALIDATE, <span class="php-quote">'function'</span>,self::SkuBillModel_create_), <span class="php-comment">//bill_class不合法</span>
</span><span id="23" class="l"><a href="#23"> 23: </a>        <span class="php-keyword1">array</span>(<span class="php-quote">'bill_status'</span>, <span class="php-quote">'isNonnegativeInt'</span>,-<span class="php-num">14005</span>,
</span><span id="24" class="l"><a href="#24"> 24: </a>            self::MUST_VALIDATE, <span class="php-quote">'function'</span>,self::SkuBillModel_create_), <span class="php-comment">//bill_status不合法</span>
</span><span id="25" class="l"><a href="#25"> 25: </a>        <span class="php-keyword1">array</span>(<span class="php-quote">'reg_time'</span>, <span class="php-quote">'isUnsignedInt'</span>,-<span class="php-num">14006</span>,
</span><span id="26" class="l"><a href="#26"> 26: </a>            self::MUST_VALIDATE, <span class="php-quote">'function'</span>,self::SkuBillModel_create_), <span class="php-comment">//reg_time不合法</span>
</span><span id="27" class="l"><a href="#27"> 27: </a>        <span class="php-keyword1">array</span>(<span class="php-quote">'oid'</span>, <span class="php-quote">'isUnsignedInt'</span>,-<span class="php-num">14007</span>,
</span><span id="28" class="l"><a href="#28"> 28: </a>            self::EXISTS_VALIDATE, <span class="php-quote">'function'</span>,self::SkuBillModel_create_), <span class="php-comment">//oid不合法</span>
</span><span id="29" class="l"><a href="#29"> 29: </a>        <span class="php-keyword1">array</span>(<span class="php-quote">'wid'</span>, <span class="php-quote">'isUnsignedInt'</span>,-<span class="php-num">14008</span>,
</span><span id="30" class="l"><a href="#30"> 30: </a>            self::EXISTS_VALIDATE, <span class="php-quote">'function'</span>,self::SkuBillModel_create_), <span class="php-comment">//wid不合法</span>
</span><span id="31" class="l"><a href="#31"> 31: </a>
</span><span id="32" class="l"><a href="#32"> 32: </a>        <span class="php-comment">//SkuBillModel_queryOrderAndWarehouse</span>
</span><span id="33" class="l"><a href="#33"> 33: </a>        <span class="php-keyword1">array</span>(<span class="php-quote">'sku_id'</span>, <span class="php-quote">'isUnsignedInt'</span>,-<span class="php-num">14002</span>,
</span><span id="34" class="l"><a href="#34"> 34: </a>            self::MUST_VALIDATE, <span class="php-quote">'function'</span>,self::SkuBillModel_queryOrderAndWarehouse), <span class="php-comment">//sku_id不合法</span>
</span><span id="35" class="l"><a href="#35"> 35: </a>    );
</span><span id="36" class="l"><a href="#36"> 36: </a>
</span><span id="37" class="l"><a href="#37"> 37: </a>
</span><span id="38" class="l"><a href="#38"> 38: </a>
</span><span id="39" class="l"><a href="#39"> 39: </a>
</span><span id="40" class="l"><a href="#40"> 40: </a>    <span class="php-comment">/* 自动完成 */</span>
</span><span id="41" class="l"><a href="#41"> 41: </a>    <span class="php-keyword1">protected</span> <span class="php-var">$_auto</span> = <span class="php-keyword1">array</span>(
</span><span id="42" class="l"><a href="#42"> 42: </a>        <span class="php-keyword1">array</span>(<span class="php-quote">'admin_uid'</span>,<span class="php-quote">'getAdminUid'</span>,self::SkuBillModel_create_,<span class="php-quote">'function'</span>),<span class="php-comment">//填入所属创建者uid</span>
</span><span id="43" class="l"><a href="#43"> 43: </a>        <span class="php-keyword1">array</span>(<span class="php-quote">'admin_uid'</span>,<span class="php-quote">'getAdminUid'</span>,self::SkuBillModel_queryOrderAndWarehouse,<span class="php-quote">'function'</span>),<span class="php-comment">//填入所属创建者uid</span>
</span><span id="44" class="l"><a href="#44"> 44: </a>    );
</span><span id="45" class="l"><a href="#45"> 45: </a>
</span><span id="46" class="l"><a href="#46"> 46: </a>
</span><span id="47" class="l"><a href="#47"> 47: </a>    <span class="php-comment">/**
</span></span><span id="48" class="l"><a href="#48"> 48: </a><span class="php-comment">     * 创建sku/spu与单据的关联记录
</span></span><span id="49" class="l"><a href="#49"> 49: </a><span class="php-comment">     * @internal server
</span></span><span id="50" class="l"><a href="#50"> 50: </a><span class="php-comment">     *
</span></span><span id="51" class="l"><a href="#51"> 51: </a><span class="php-comment">     * @param mixed|null $data POST的数据
</span></span><span id="52" class="l"><a href="#52"> 52: </a><span class="php-comment">     * 
</span></span><span id="53" class="l"><a href="#53"> 53: </a><span class="php-comment">     * - 必填参数：
</span></span><span id="54" class="l"><a href="#54"> 54: </a><span class="php-comment">     * - @param unsigned_int $sku_id
</span></span><span id="55" class="l"><a href="#55"> 55: </a><span class="php-comment">     * - @param unsigned_int $spu_id
</span></span><span id="56" class="l"><a href="#56"> 56: </a><span class="php-comment">     * - @param unsigned_int $bill_class oid或wid的原单据的类别
</span></span><span id="57" class="l"><a href="#57"> 57: </a><span class="php-comment">     * - @param unsigned_int $bill_status oid或wid的原单据的状态
</span></span><span id="58" class="l"><a href="#58"> 58: </a><span class="php-comment">     * - @param unsigned_int $reg_time oid或者wid的单据创建时间，为了保持和交易单或库管单时间的一致，所以需要传入，而不是动态获取
</span></span><span id="59" class="l"><a href="#59"> 59: </a><span class="php-comment">     * - 选填参数（以下两个二选一）：
</span></span><span id="60" class="l"><a href="#60"> 60: </a><span class="php-comment">     * - @param unsigned_int $oid
</span></span><span id="61" class="l"><a href="#61"> 61: </a><span class="php-comment">     * - @param unsigned_int $wid
</span></span><span id="62" class="l"><a href="#62"> 62: </a><span class="php-comment">     *
</span></span><span id="63" class="l"><a href="#63"> 63: </a><span class="php-comment">     * @return 1 ok
</span></span><span id="64" class="l"><a href="#64"> 64: </a><span class="php-comment">     * @throws \XYException
</span></span><span id="65" class="l"><a href="#65"> 65: </a><span class="php-comment">     * 
</span></span><span id="66" class="l"><a href="#66"> 66: </a><span class="php-comment">     * @author co8bit &lt;me@co8bit.com&gt;
</span></span><span id="67" class="l"><a href="#67"> 67: </a><span class="php-comment">     * @version 1.1
</span></span><span id="68" class="l"><a href="#68"> 68: </a><span class="php-comment">     * @date    2016-10-30
</span></span><span id="69" class="l"><a href="#69"> 69: </a><span class="php-comment">     */</span>
</span><span id="70" class="l"><a href="#70"> 70: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> create_(<span class="php-keyword1">array</span> <span class="php-var">$data</span> = <span class="php-keyword1">null</span>)
</span><span id="71" class="l"><a href="#71"> 71: </a>    {
</span><span id="72" class="l"><a href="#72"> 72: </a>        <span class="php-keyword1">if</span> (!<span class="php-var">$this</span>-&gt;field(<span class="php-quote">'sku_id,spu_id,oid,wid,bill_class,bill_status,reg_time'</span>)-&gt;create(<span class="php-var">$data</span>,self::SkuBillModel_create_))
</span><span id="73" class="l"><a href="#73"> 73: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,<span class="php-var">$this</span>-&gt;getError());
</span><span id="74" class="l"><a href="#74"> 74: </a>
</span><span id="75" class="l"><a href="#75"> 75: </a>        <span class="php-keyword1">if</span> ( (<span class="php-keyword1">empty</span>(<span class="php-var">$this</span>-&gt;oid)) &amp;&amp; (<span class="php-keyword1">empty</span>(<span class="php-var">$this</span>-&gt;wid)) )
</span><span id="76" class="l"><a href="#76"> 76: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14009</span>);
</span><span id="77" class="l"><a href="#77"> 77: </a>
</span><span id="78" class="l"><a href="#78"> 78: </a>        <span class="php-var">$tmpReturn</span> = <span class="php-var">$this</span>-&gt;add();
</span><span id="79" class="l"><a href="#79"> 79: </a>
</span><span id="80" class="l"><a href="#80"> 80: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$tmpReturn</span> &gt; <span class="php-num">0</span>)
</span><span id="81" class="l"><a href="#81"> 81: </a>            <span class="php-keyword1">return</span> <span class="php-num">1</span>;
</span><span id="82" class="l"><a href="#82"> 82: </a>        <span class="php-keyword1">else</span>
</span><span id="83" class="l"><a href="#83"> 83: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14000</span>);
</span><span id="84" class="l"><a href="#84"> 84: </a>    }
</span><span id="85" class="l"><a href="#85"> 85: </a>
</span><span id="86" class="l"><a href="#86"> 86: </a>
</span><span id="87" class="l"><a href="#87"> 87: </a>
</span><span id="88" class="l"><a href="#88"> 88: </a>    <span class="php-comment">/**
</span></span><span id="89" class="l"><a href="#89"> 89: </a><span class="php-comment">     * 得到sku、spu是否已经产生了业务往来
</span></span><span id="90" class="l"><a href="#90"> 90: </a><span class="php-comment">     * @internal server
</span></span><span id="91" class="l"><a href="#91"> 91: </a><span class="php-comment">     *
</span></span><span id="92" class="l"><a href="#92"> 92: </a><span class="php-comment">     * @param unsigned_int $id 要查询的sku_id或spu_id的值
</span></span><span id="93" class="l"><a href="#93"> 93: </a><span class="php-comment">     * @param enum $type 'sku'|'spu'.  'sku'-要查sku是否发生了业务往来，'spu'-要查spu是否发生了业务往来
</span></span><span id="94" class="l"><a href="#94"> 94: </a><span class="php-comment">     *
</span></span><span id="95" class="l"><a href="#95"> 95: </a><span class="php-comment">     * @return bool true-发生了业务往来,false-没发送业务往来
</span></span><span id="96" class="l"><a href="#96"> 96: </a><span class="php-comment">     * @throws \XYException
</span></span><span id="97" class="l"><a href="#97"> 97: </a><span class="php-comment">     *
</span></span><span id="98" class="l"><a href="#98"> 98: </a><span class="php-comment">     * @author co8bit &lt;me@co8bit.com&gt;
</span></span><span id="99" class="l"><a href="#99"> 99: </a><span class="php-comment">     * @version 1.1
</span></span><span id="100" class="l"><a href="#100">100: </a><span class="php-comment">     * @date    2016-10-31
</span></span><span id="101" class="l"><a href="#101">101: </a><span class="php-comment">     */</span>
</span><span id="102" class="l"><a href="#102">102: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> isHasContacts(<span class="php-var">$id</span>,<span class="php-var">$type</span>)
</span><span id="103" class="l"><a href="#103">103: </a>    {
</span><span id="104" class="l"><a href="#104">104: </a>        <span class="php-keyword1">if</span> (!isUnsignedInt(<span class="php-var">$id</span>)) <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14501</span>);
</span><span id="105" class="l"><a href="#105">105: </a>        <span class="php-keyword1">if</span> ( (<span class="php-var">$type</span> === <span class="php-quote">'sku'</span>) || (<span class="php-var">$type</span> === <span class="php-quote">'spu'</span>) )
</span><span id="106" class="l"><a href="#106">106: </a>            ;
</span><span id="107" class="l"><a href="#107">107: </a>        <span class="php-keyword1">else</span>
</span><span id="108" class="l"><a href="#108">108: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14502</span>);
</span><span id="109" class="l"><a href="#109">109: </a>
</span><span id="110" class="l"><a href="#110">110: </a>        <span class="php-var">$key</span> = <span class="php-var">$type</span>.<span class="php-quote">'_id'</span>;
</span><span id="111" class="l"><a href="#111">111: </a>        <span class="php-var">$tmp</span> = <span class="php-var">$this</span>-&gt;where(<span class="php-keyword1">array</span>(<span class="php-var">$key</span>=&gt;<span class="php-var">$id</span>,<span class="php-quote">'admin_uid'</span>=&gt;getAdminUid()))-&gt;find();
</span><span id="112" class="l"><a href="#112">112: </a>
</span><span id="113" class="l"><a href="#113">113: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$tmp</span> === <span class="php-keyword1">false</span>)
</span><span id="114" class="l"><a href="#114">114: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14000</span>);
</span><span id="115" class="l"><a href="#115">115: </a>        <span class="php-keyword1">elseif</span> (<span class="php-keyword1">empty</span>(<span class="php-var">$tmp</span>))
</span><span id="116" class="l"><a href="#116">116: </a>            <span class="php-keyword1">return</span> <span class="php-keyword1">false</span>;
</span><span id="117" class="l"><a href="#117">117: </a>        <span class="php-keyword1">else</span>
</span><span id="118" class="l"><a href="#118">118: </a>            <span class="php-keyword1">return</span> <span class="php-keyword1">true</span>;
</span><span id="119" class="l"><a href="#119">119: </a>    }
</span><span id="120" class="l"><a href="#120">120: </a>
</span><span id="121" class="l"><a href="#121">121: </a>
</span><span id="122" class="l"><a href="#122">122: </a>
</span><span id="123" class="l"><a href="#123">123: </a>
</span><span id="124" class="l"><a href="#124">124: </a>    <span class="php-comment">/**
</span></span><span id="125" class="l"><a href="#125">125: </a><span class="php-comment">     * SKU 详情，查看业务往来
</span></span><span id="126" class="l"><a href="#126">126: </a><span class="php-comment">     * @internal server
</span></span><span id="127" class="l"><a href="#127">127: </a><span class="php-comment">     * @param mixed|null $data POST的数据
</span></span><span id="128" class="l"><a href="#128">128: </a><span class="php-comment">     * @param unsigned_int $sku_id 要查询的sku_id
</span></span><span id="129" class="l"><a href="#129">129: </a><span class="php-comment">     * @param unsigned_int $reg_st_time 订单过滤开始时间
</span></span><span id="130" class="l"><a href="#130">130: </a><span class="php-comment">     * @param unsigned_int $reg_end_time 订单过滤结束时间
</span></span><span id="131" class="l"><a href="#131">131: </a><span class="php-comment">     * @param string       $field  查询结果所需要的字段
</span></span><span id="132" class="l"><a href="#132">132: </a><span class="php-comment">     * @param unsigned_int $sto_id sku所在的仓库id
</span></span><span id="133" class="l"><a href="#133">133: </a><span class="php-comment">     * @param json $filter class、status 
</span></span><span id="134" class="l"><a href="#134">134: </a><span class="php-comment">     *        - array $class 单据类别编号：不传代表全部。
</span></span><span id="135" class="l"><a href="#135">135: </a><span class="php-comment">     *        - array $status 单据状态：不传代表全部，a-可选值：1、2、5、90.  b-未完成传90。
</span></span><span id="136" class="l"><a href="#136">136: </a><span class="php-comment">     *
</span></span><span id="137" class="l"><a href="#137">137: </a><span class="php-comment">     * @return array 返回订单的数组和统计数据
</span></span><span id="138" class="l"><a href="#138">138: </a><span class="php-comment">     * @throws \XYException
</span></span><span id="139" class="l"><a href="#139">139: </a><span class="php-comment">     *
</span></span><span id="140" class="l"><a href="#140">140: </a><span class="php-comment">     * @author wtt &lt;wtt@xingyunbooks.com&gt;
</span></span><span id="141" class="l"><a href="#141">141: </a><span class="php-comment">     * @version 1.9
</span></span><span id="142" class="l"><a href="#142">142: </a><span class="php-comment">     * @date    2017-05-01
</span></span><span id="143" class="l"><a href="#143">143: </a><span class="php-comment">     */</span>
</span><span id="144" class="l"><a href="#144">144: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> queryOrderAndWarehouse(<span class="php-keyword1">array</span> <span class="php-var">$data</span> = <span class="php-keyword1">null</span>)
</span><span id="145" class="l"><a href="#145">145: </a>    {
</span><span id="146" class="l"><a href="#146">146: </a>        <span class="php-comment">//验证数据是否合法</span>
</span><span id="147" class="l"><a href="#147">147: </a>        <span class="php-keyword1">if</span>(!<span class="php-var">$this</span>-&gt;field(<span class="php-quote">'sku_id'</span>)-&gt;create(<span class="php-var">$data</span>,self::SkuBillModel_queryOrderAndWarehouse))
</span><span id="148" class="l"><a href="#148">148: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,<span class="php-var">$this</span>-&gt;getError());
</span><span id="149" class="l"><a href="#149">149: </a>
</span><span id="150" class="l"><a href="#150">150: </a>        <span class="php-comment">//手动验证其他字段</span>
</span><span id="151" class="l"><a href="#151">151: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword1">isset</span>(<span class="php-var">$data</span>[<span class="php-quote">'page'</span>]))
</span><span id="152" class="l"><a href="#152">152: </a>        {
</span><span id="153" class="l"><a href="#153">153: </a>            <span class="php-keyword1">if</span> (isUnsignedInt(<span class="php-var">$data</span>[<span class="php-quote">'page'</span>]))
</span><span id="154" class="l"><a href="#154">154: </a>                <span class="php-var">$this</span>-&gt;page = <span class="php-var">$data</span>[<span class="php-quote">'page'</span>];
</span><span id="155" class="l"><a href="#155">155: </a>            <span class="php-keyword1">else</span>
</span><span id="156" class="l"><a href="#156">156: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14010</span>);
</span><span id="157" class="l"><a href="#157">157: </a>        }
</span><span id="158" class="l"><a href="#158">158: </a>
</span><span id="159" class="l"><a href="#159">159: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword1">isset</span>(<span class="php-var">$data</span>[<span class="php-quote">'pline'</span>]))
</span><span id="160" class="l"><a href="#160">160: </a>        {
</span><span id="161" class="l"><a href="#161">161: </a>            <span class="php-keyword1">if</span>(isUnsignedInt(<span class="php-var">$data</span>[<span class="php-quote">'pline'</span>]))
</span><span id="162" class="l"><a href="#162">162: </a>                <span class="php-var">$this</span>-&gt;pline = <span class="php-var">$data</span>[<span class="php-quote">'pline'</span>];
</span><span id="163" class="l"><a href="#163">163: </a>            <span class="php-keyword1">else</span>
</span><span id="164" class="l"><a href="#164">164: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14011</span>);
</span><span id="165" class="l"><a href="#165">165: </a>        }
</span><span id="166" class="l"><a href="#166">166: </a>
</span><span id="167" class="l"><a href="#167">167: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword1">isset</span>(<span class="php-var">$data</span>[<span class="php-quote">'reg_st_time'</span>]))
</span><span id="168" class="l"><a href="#168">168: </a>        { 
</span><span id="169" class="l"><a href="#169">169: </a>            <span class="php-keyword1">if</span>(<span class="php-var">$this</span>-&gt;check_unix_date(<span class="php-var">$data</span>[<span class="php-quote">'reg_st_time'</span>]))
</span><span id="170" class="l"><a href="#170">170: </a>                <span class="php-var">$this</span>-&gt;reg_st_time = <span class="php-var">$data</span>[<span class="php-quote">'reg_st_time'</span>];
</span><span id="171" class="l"><a href="#171">171: </a>            <span class="php-keyword1">else</span>
</span><span id="172" class="l"><a href="#172">172: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14012</span>);
</span><span id="173" class="l"><a href="#173">173: </a>        }
</span><span id="174" class="l"><a href="#174">174: </a>
</span><span id="175" class="l"><a href="#175">175: </a>
</span><span id="176" class="l"><a href="#176">176: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword1">isset</span>(<span class="php-var">$data</span>[<span class="php-quote">'reg_end_time'</span>]))
</span><span id="177" class="l"><a href="#177">177: </a>        {
</span><span id="178" class="l"><a href="#178">178: </a>            <span class="php-keyword1">if</span>(<span class="php-var">$this</span>-&gt;check_unix_date(<span class="php-var">$data</span>[<span class="php-quote">'reg_end_time'</span>]))
</span><span id="179" class="l"><a href="#179">179: </a>                <span class="php-var">$this</span>-&gt;reg_end_time = <span class="php-var">$data</span>[<span class="php-quote">'reg_end_time'</span>];
</span><span id="180" class="l"><a href="#180">180: </a>            <span class="php-keyword1">else</span>
</span><span id="181" class="l"><a href="#181">181: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14013</span>); 
</span><span id="182" class="l"><a href="#182">182: </a>        }
</span><span id="183" class="l"><a href="#183">183: </a>
</span><span id="184" class="l"><a href="#184">184: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword2">is_string</span>(<span class="php-var">$data</span>[<span class="php-quote">'field'</span>]))
</span><span id="185" class="l"><a href="#185">185: </a>            <span class="php-var">$this</span>-&gt;field = <span class="php-var">$data</span>[<span class="php-quote">'field'</span>];
</span><span id="186" class="l"><a href="#186">186: </a>        <span class="php-keyword1">else</span>
</span><span id="187" class="l"><a href="#187">187: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14014</span>);
</span><span id="188" class="l"><a href="#188">188: </a>
</span><span id="189" class="l"><a href="#189">189: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword1">isset</span>(<span class="php-var">$data</span>[<span class="php-quote">'sto_id'</span>]))
</span><span id="190" class="l"><a href="#190">190: </a>        {
</span><span id="191" class="l"><a href="#191">191: </a>            <span class="php-keyword1">if</span>(isUnsignedInt(<span class="php-var">$data</span>[<span class="php-quote">'sto_id'</span>]))
</span><span id="192" class="l"><a href="#192">192: </a>                <span class="php-var">$this</span>-&gt;sto_id = <span class="php-var">$data</span>[<span class="php-quote">'sto_id'</span>];
</span><span id="193" class="l"><a href="#193">193: </a>            <span class="php-keyword1">else</span>
</span><span id="194" class="l"><a href="#194">194: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14015</span>);
</span><span id="195" class="l"><a href="#195">195: </a>        }
</span><span id="196" class="l"><a href="#196">196: </a>        <span class="php-keyword1">else</span>
</span><span id="197" class="l"><a href="#197">197: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14015</span>);
</span><span id="198" class="l"><a href="#198">198: </a>
</span><span id="199" class="l"><a href="#199">199: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword1">isset</span>(<span class="php-var">$data</span>[<span class="php-quote">'filter'</span>])){
</span><span id="200" class="l"><a href="#200">200: </a>            <span class="php-keyword1">if</span>(<span class="php-keyword2">is_string</span>(<span class="php-var">$data</span>[<span class="php-quote">'filter'</span>]))
</span><span id="201" class="l"><a href="#201">201: </a>                <span class="php-var">$this</span>-&gt;filter = <span class="php-var">$data</span>[<span class="php-quote">'filter'</span>];
</span><span id="202" class="l"><a href="#202">202: </a>            <span class="php-keyword1">else</span>
</span><span id="203" class="l"><a href="#203">203: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14050</span>);
</span><span id="204" class="l"><a href="#204">204: </a>        }
</span><span id="205" class="l"><a href="#205">205: </a>
</span><span id="206" class="l"><a href="#206">206: </a>
</span><span id="207" class="l"><a href="#207">207: </a>        <span class="php-var">$filter</span> = <span class="php-keyword2">json_decode</span>(I(<span class="php-quote">'param.filter'</span>,<span class="php-quote">''</span>,<span class="php-quote">''</span>),<span class="php-keyword1">true</span>);
</span><span id="208" class="l"><a href="#208">208: </a>        <span class="php-keyword1">if</span>(!<span class="php-keyword1">empty</span>(<span class="php-var">$data</span>[<span class="php-quote">'filter'</span>])){
</span><span id="209" class="l"><a href="#209">209: </a>            <span class="php-comment">//filter条件不为空的时候判断转换是否成功</span>
</span><span id="210" class="l"><a href="#210">210: </a>            <span class="php-keyword1">if</span>(<span class="php-keyword1">empty</span>(<span class="php-var">$filter</span>))
</span><span id="211" class="l"><a href="#211">211: </a>            {
</span><span id="212" class="l"><a href="#212">212: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14050</span>);
</span><span id="213" class="l"><a href="#213">213: </a>            }
</span><span id="214" class="l"><a href="#214">214: </a>        }
</span><span id="215" class="l"><a href="#215">215: </a>
</span><span id="216" class="l"><a href="#216">216: </a>        <span class="php-comment">// 判断前端传递的sku_id在数据库中是否存在;</span>
</span><span id="217" class="l"><a href="#217">217: </a>        <span class="php-var">$tmp</span> = D(<span class="php-quote">'sku'</span>)-&gt;get_(<span class="php-keyword1">array</span>(<span class="php-quote">'sku_id'</span>=&gt;<span class="php-var">$this</span>-&gt;sku_id));
</span><span id="218" class="l"><a href="#218">218: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword1">empty</span>(<span class="php-var">$tmp</span>)){
</span><span id="219" class="l"><a href="#219">219: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14002</span>);
</span><span id="220" class="l"><a href="#220">220: </a>        }
</span><span id="221" class="l"><a href="#221">221: </a>
</span><span id="222" class="l"><a href="#222">222: </a>        <span class="php-comment">// 根据 SKU ID 获取其所在的 N 个订单的编号</span>
</span><span id="223" class="l"><a href="#223">223: </a>        <span class="php-var">$skuBillRet</span> = <span class="php-var">$this</span>-&gt;field(<span class="php-quote">'oid,wid'</span>)
</span><span id="224" class="l"><a href="#224">224: </a>            -&gt;where(<span class="php-keyword1">array</span>(<span class="php-quote">'sku_id'</span> =&gt; <span class="php-var">$this</span>-&gt;sku_id,<span class="php-quote">'admin_uid'</span>=&gt;getAdminUid()))-&gt;select();
</span><span id="225" class="l"><a href="#225">225: </a>
</span><span id="226" class="l"><a href="#226">226: </a>        <span class="php-comment">// 遍历订单获取所有 OID,WID 单独存储,以备查询</span>
</span><span id="227" class="l"><a href="#227">227: </a>        <span class="php-var">$oidList</span> = <span class="php-keyword1">array</span>();
</span><span id="228" class="l"><a href="#228">228: </a>        <span class="php-var">$widList</span> = <span class="php-keyword1">array</span>();
</span><span id="229" class="l"><a href="#229">229: </a>        <span class="php-keyword1">foreach</span>(<span class="php-var">$skuBillRet</span> <span class="php-keyword1">as</span> <span class="php-var">$item</span> =&gt; <span class="php-var">$value</span>){
</span><span id="230" class="l"><a href="#230">230: </a>            <span class="php-comment">// 一个 SKU ,WID 和 OID 不会同时存在</span>
</span><span id="231" class="l"><a href="#231">231: </a>            <span class="php-keyword1">if</span>(<span class="php-keyword2">intval</span>(<span class="php-var">$value</span>[<span class="php-quote">'oid'</span>]) != <span class="php-num">0</span>){
</span><span id="232" class="l"><a href="#232">232: </a>                <span class="php-var">$oidList</span>[] = <span class="php-var">$value</span>[<span class="php-quote">'oid'</span>];
</span><span id="233" class="l"><a href="#233">233: </a>            }
</span><span id="234" class="l"><a href="#234">234: </a>            <span class="php-keyword1">elseif</span>(<span class="php-keyword2">intval</span>(<span class="php-var">$value</span>[<span class="php-quote">'wid'</span>]) != <span class="php-num">0</span>){
</span><span id="235" class="l"><a href="#235">235: </a>                <span class="php-var">$widList</span>[] = <span class="php-var">$value</span>[<span class="php-quote">'wid'</span>];
</span><span id="236" class="l"><a href="#236">236: </a>            }
</span><span id="237" class="l"><a href="#237">237: </a>        }
</span><span id="238" class="l"><a href="#238">238: </a>
</span><span id="239" class="l"><a href="#239">239: </a>        <span class="php-comment">// 拼接 condition</span>
</span><span id="240" class="l"><a href="#240">240: </a>        <span class="php-var">$commondition</span> = <span class="php-keyword1">array</span>();
</span><span id="241" class="l"><a href="#241">241: </a>        <span class="php-comment">// 处理订单过滤开始和结束时间</span>
</span><span id="242" class="l"><a href="#242">242: </a>        <span class="php-keyword1">if</span>(!<span class="php-keyword1">isset</span>(<span class="php-var">$data</span>[<span class="php-quote">'reg_st_time'</span>]))
</span><span id="243" class="l"><a href="#243">243: </a>        {
</span><span id="244" class="l"><a href="#244">244: </a>            <span class="php-keyword1">unset</span>(<span class="php-var">$this</span>-&gt;reg_st_time);
</span><span id="245" class="l"><a href="#245">245: </a>        }<span class="php-keyword1">else</span>
</span><span id="246" class="l"><a href="#246">246: </a>        {
</span><span id="247" class="l"><a href="#247">247: </a>            <span class="php-var">$tmpDate</span> = <span class="php-keyword1">null</span>;
</span><span id="248" class="l"><a href="#248">248: </a>            <span class="php-var">$tmpDate</span> = <span class="php-keyword2">getdate</span>(<span class="php-var">$this</span>-&gt;reg_st_time);
</span><span id="249" class="l"><a href="#249">249: </a>            <span class="php-var">$this</span>-&gt;reg_st_time = <span class="php-keyword2">mktime</span>(<span class="php-quote">'0'</span>,<span class="php-quote">'0'</span>,<span class="php-quote">'0'</span>,<span class="php-var">$tmpDate</span>[<span class="php-quote">'mon'</span>],<span class="php-var">$tmpDate</span>[<span class="php-quote">'mday'</span>],<span class="php-var">$tmpDate</span>[<span class="php-quote">'year'</span>]);
</span><span id="250" class="l"><a href="#250">250: </a>        }
</span><span id="251" class="l"><a href="#251">251: </a>
</span><span id="252" class="l"><a href="#252">252: </a>        <span class="php-keyword1">if</span>(!<span class="php-keyword1">isset</span>(<span class="php-var">$data</span>[<span class="php-quote">'reg_end_time'</span>])){
</span><span id="253" class="l"><a href="#253">253: </a>            <span class="php-keyword1">unset</span>(<span class="php-var">$this</span>-&gt;reg_end_time);
</span><span id="254" class="l"><a href="#254">254: </a>        }<span class="php-keyword1">else</span>
</span><span id="255" class="l"><a href="#255">255: </a>        {
</span><span id="256" class="l"><a href="#256">256: </a>            <span class="php-var">$tmpDate</span> = <span class="php-keyword1">null</span>;
</span><span id="257" class="l"><a href="#257">257: </a>            <span class="php-var">$tmpDate</span> = <span class="php-keyword2">getdate</span>(<span class="php-var">$this</span>-&gt;reg_end_time);
</span><span id="258" class="l"><a href="#258">258: </a>            <span class="php-var">$this</span>-&gt;reg_end_time = <span class="php-keyword2">mktime</span>(<span class="php-quote">'23'</span>,<span class="php-quote">'59'</span>,<span class="php-quote">'59'</span>,<span class="php-var">$tmpDate</span>[<span class="php-quote">'mon'</span>],<span class="php-var">$tmpDate</span>[<span class="php-quote">'mday'</span>],<span class="php-var">$tmpDate</span>[<span class="php-quote">'year'</span>]);
</span><span id="259" class="l"><a href="#259">259: </a>        }
</span><span id="260" class="l"><a href="#260">260: </a>
</span><span id="261" class="l"><a href="#261">261: </a>        <span class="php-comment">// 判断时间条件</span>
</span><span id="262" class="l"><a href="#262">262: </a>        <span class="php-keyword1">if</span> ( <span class="php-keyword1">isset</span>(<span class="php-var">$this</span>-&gt;reg_st_time) &amp;&amp; <span class="php-keyword1">isset</span>(<span class="php-var">$this</span>-&gt;reg_end_time))
</span><span id="263" class="l"><a href="#263">263: </a>        {
</span><span id="264" class="l"><a href="#264">264: </a>            <span class="php-var">$commonCondition</span>[<span class="php-quote">'reg_time'</span>]  = <span class="php-keyword1">array</span>(<span class="php-quote">'between'</span>,<span class="php-keyword1">array</span>(<span class="php-var">$this</span>-&gt;reg_st_time,<span class="php-var">$this</span>-&gt;reg_end_time));
</span><span id="265" class="l"><a href="#265">265: </a>        }<span class="php-keyword1">elseif</span>( <span class="php-keyword1">isset</span>(<span class="php-var">$this</span>-&gt;reg_st_time) &amp;&amp; !<span class="php-keyword1">isset</span>(<span class="php-var">$this</span>-&gt;reg_end_time))
</span><span id="266" class="l"><a href="#266">266: </a>        {
</span><span id="267" class="l"><a href="#267">267: </a>            <span class="php-var">$commonCondition</span>[<span class="php-quote">'reg_time'</span>]  = <span class="php-keyword1">array</span>(<span class="php-quote">'egt'</span>,<span class="php-var">$this</span>-&gt;reg_st_time);
</span><span id="268" class="l"><a href="#268">268: </a>        }
</span><span id="269" class="l"><a href="#269">269: </a>        <span class="php-keyword1">elseif</span> ( (!<span class="php-keyword1">isset</span>(<span class="php-var">$this</span>-&gt;reg_st_time)) &amp;&amp; (<span class="php-keyword1">isset</span>(<span class="php-var">$this</span>-&gt;reg_end_time)))
</span><span id="270" class="l"><a href="#270">270: </a>        {
</span><span id="271" class="l"><a href="#271">271: </a>            <span class="php-var">$commonCondition</span>[<span class="php-quote">'reg_time'</span>]  = <span class="php-keyword1">array</span>(<span class="php-quote">'elt'</span>,<span class="php-var">$this</span>-&gt;reg_end_time);
</span><span id="272" class="l"><a href="#272">272: </a>        }
</span><span id="273" class="l"><a href="#273">273: </a>
</span><span id="274" class="l"><a href="#274">274: </a>        <span class="php-comment">//设置oid、wid</span>
</span><span id="275" class="l"><a href="#275">275: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword2">count</span>(<span class="php-var">$oidList</span>) &gt; <span class="php-num">0</span>)
</span><span id="276" class="l"><a href="#276">276: </a>            <span class="php-var">$orderMap</span>[<span class="php-quote">'oid'</span>] = <span class="php-keyword1">array</span>(<span class="php-quote">'in'</span>,<span class="php-var">$oidList</span>);
</span><span id="277" class="l"><a href="#277">277: </a>        <span class="php-keyword1">else</span>
</span><span id="278" class="l"><a href="#278">278: </a>            <span class="php-var">$orderMap</span>[<span class="php-quote">'oid'</span>] = <span class="php-keyword1">null</span>;
</span><span id="279" class="l"><a href="#279">279: </a>
</span><span id="280" class="l"><a href="#280">280: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword2">count</span>(<span class="php-var">$widList</span>) &gt; <span class="php-num">0</span>)
</span><span id="281" class="l"><a href="#281">281: </a>            <span class="php-var">$warehouseMap</span>[<span class="php-quote">'wid'</span>] = <span class="php-keyword1">array</span>(<span class="php-quote">'in'</span>,<span class="php-var">$widList</span>);
</span><span id="282" class="l"><a href="#282">282: </a>        <span class="php-keyword1">else</span>
</span><span id="283" class="l"><a href="#283">283: </a>            <span class="php-var">$warehouseMap</span>[<span class="php-quote">'wid'</span>] = <span class="php-keyword1">null</span>;
</span><span id="284" class="l"><a href="#284">284: </a>        <span class="php-comment">//设置仓库</span>
</span><span id="285" class="l"><a href="#285">285: </a>        <span class="php-var">$orderMap</span>[<span class="php-quote">'sto_id'</span>] = <span class="php-var">$this</span>-&gt;sto_id;
</span><span id="286" class="l"><a href="#286">286: </a>
</span><span id="287" class="l"><a href="#287">287: </a>        <span class="php-comment">//设置class</span>
</span><span id="288" class="l"><a href="#288">288: </a>        <span class="php-var">$class</span> = <span class="php-keyword1">array</span>(<span class="php-num">1</span>,<span class="php-num">2</span>,<span class="php-num">3</span>,<span class="php-num">4</span>,<span class="php-num">53</span>,<span class="php-num">54</span>);
</span><span id="289" class="l"><a href="#289">289: </a>        <span class="php-keyword1">if</span>(!<span class="php-keyword1">empty</span>(<span class="php-var">$filter</span>[<span class="php-quote">'class'</span>])){
</span><span id="290" class="l"><a href="#290">290: </a>            <span class="php-var">$classCondition</span> = <span class="php-quote">'('</span>;
</span><span id="291" class="l"><a href="#291">291: </a>            <span class="php-keyword1">foreach</span>(<span class="php-var">$filter</span>[<span class="php-quote">'class'</span>] <span class="php-keyword1">as</span> <span class="php-var">$value</span>){
</span><span id="292" class="l"><a href="#292">292: </a>                <span class="php-var">$value</span> = <span class="php-keyword2">intval</span>(<span class="php-var">$value</span>);
</span><span id="293" class="l"><a href="#293">293: </a>                <span class="php-keyword1">if</span>(<span class="php-var">$this</span>-&gt;checkDeny_query_class(<span class="php-var">$value</span>)){
</span><span id="294" class="l"><a href="#294">294: </a>                    <span class="php-comment">//排除class值非1,2,3,4,53,54（销售单、销售退货单、采购单、采购退货单、盘点单、调拨单）的订单</span>
</span><span id="295" class="l"><a href="#295">295: </a>                    <span class="php-keyword1">if</span>(<span class="php-keyword2">in_array</span>(<span class="php-var">$value</span>,<span class="php-var">$class</span>))
</span><span id="296" class="l"><a href="#296">296: </a>                    { 
</span><span id="297" class="l"><a href="#297">297: </a>                        <span class="php-keyword1">if</span>(<span class="php-var">$classCondition</span> === <span class="php-quote">'('</span>){
</span><span id="298" class="l"><a href="#298">298: </a>                            <span class="php-var">$classCondition</span> = <span class="php-quote">'( `class` = '</span>.<span class="php-var">$value</span>;
</span><span id="299" class="l"><a href="#299">299: </a>                        }<span class="php-keyword1">else</span>
</span><span id="300" class="l"><a href="#300">300: </a>                        {
</span><span id="301" class="l"><a href="#301">301: </a>                            <span class="php-var">$classCondition</span> .= <span class="php-quote">' or `class`='</span>.<span class="php-var">$value</span>;
</span><span id="302" class="l"><a href="#302">302: </a>                        }
</span><span id="303" class="l"><a href="#303">303: </a>                    }
</span><span id="304" class="l"><a href="#304">304: </a>                    <span class="php-keyword1">else</span>
</span><span id="305" class="l"><a href="#305">305: </a>                    {
</span><span id="306" class="l"><a href="#306">306: </a>                        <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14051</span>);
</span><span id="307" class="l"><a href="#307">307: </a>                    }
</span><span id="308" class="l"><a href="#308">308: </a>                }<span class="php-keyword1">else</span>
</span><span id="309" class="l"><a href="#309">309: </a>                {
</span><span id="310" class="l"><a href="#310">310: </a>                    <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14051</span>);
</span><span id="311" class="l"><a href="#311">311: </a>                }
</span><span id="312" class="l"><a href="#312">312: </a>            }
</span><span id="313" class="l"><a href="#313">313: </a>            <span class="php-var">$classCondition</span> .= <span class="php-quote">')'</span>;
</span><span id="314" class="l"><a href="#314">314: </a>        }
</span><span id="315" class="l"><a href="#315">315: </a>
</span><span id="316" class="l"><a href="#316">316: </a>        <span class="php-comment">//设置status</span>
</span><span id="317" class="l"><a href="#317">317: </a>        <span class="php-keyword1">if</span>(!<span class="php-keyword1">empty</span>(<span class="php-var">$filter</span>[<span class="php-quote">'status'</span>])){
</span><span id="318" class="l"><a href="#318">318: </a>            <span class="php-var">$statusCondition</span> = <span class="php-quote">'('</span>;
</span><span id="319" class="l"><a href="#319">319: </a>            <span class="php-keyword1">foreach</span>(<span class="php-var">$filter</span>[<span class="php-quote">'status'</span>] <span class="php-keyword1">as</span> <span class="php-var">$value</span>){
</span><span id="320" class="l"><a href="#320">320: </a>                <span class="php-var">$value</span> = <span class="php-keyword2">intval</span>(<span class="php-var">$value</span>);
</span><span id="321" class="l"><a href="#321">321: </a>                <span class="php-keyword1">if</span>(<span class="php-var">$this</span>-&gt;checkDeny_query_status(<span class="php-var">$value</span>)){
</span><span id="322" class="l"><a href="#322">322: </a>                    <span class="php-keyword1">if</span>(<span class="php-var">$statusCondition</span> ===<span class="php-quote">'('</span>)
</span><span id="323" class="l"><a href="#323">323: </a>                        <span class="php-var">$statusCondition</span> = <span class="php-quote">'(  `status`='</span> .<span class="php-var">$value</span>;
</span><span id="324" class="l"><a href="#324">324: </a>                    <span class="php-keyword1">else</span>
</span><span id="325" class="l"><a href="#325">325: </a>                        <span class="php-var">$statusCondition</span> .= <span class="php-quote">' or `status`='</span>.<span class="php-var">$value</span>;
</span><span id="326" class="l"><a href="#326">326: </a>                        
</span><span id="327" class="l"><a href="#327">327: </a>                    <span class="php-keyword1">if</span> (<span class="php-var">$value</span> == <span class="php-num">90</span>)
</span><span id="328" class="l"><a href="#328">328: </a>                            <span class="php-var">$statusCondition</span> .= <span class="php-quote">' or `status`=2 or `status`=4 or `status`=5 or `status`=6 or `status`=7 or `status`=8 or `status`=9 or `status`=10 or `status`=11 or `status`=12'</span>;
</span><span id="329" class="l"><a href="#329">329: </a>                    
</span><span id="330" class="l"><a href="#330">330: </a>                }<span class="php-keyword1">else</span>
</span><span id="331" class="l"><a href="#331">331: </a>                {
</span><span id="332" class="l"><a href="#332">332: </a>                    <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14052</span>);
</span><span id="333" class="l"><a href="#333">333: </a>                }
</span><span id="334" class="l"><a href="#334">334: </a>            }
</span><span id="335" class="l"><a href="#335">335: </a>            <span class="php-var">$statusCondition</span> .= <span class="php-quote">')'</span>;
</span><span id="336" class="l"><a href="#336">336: </a>            log_(<span class="php-quote">&quot;statusCondition&quot;</span>,<span class="php-var">$statusCondition</span>,<span class="php-var">$this</span>);
</span><span id="337" class="l"><a href="#337">337: </a>        }
</span><span id="338" class="l"><a href="#338">338: </a>
</span><span id="339" class="l"><a href="#339">339: </a>
</span><span id="340" class="l"><a href="#340">340: </a>        <span class="php-comment">//去掉草稿单和期初订单</span>
</span><span id="341" class="l"><a href="#341">341: </a>        <span class="php-var">$commonCondition</span>[<span class="php-quote">'status'</span>]=<span class="php-keyword1">array</span>(<span class="php-quote">'not in'</span>,<span class="php-keyword1">array</span>(<span class="php-num">99</span>,<span class="php-num">100</span>));
</span><span id="342" class="l"><a href="#342">342: </a>        <span class="php-var">$commonCondition</span>[<span class="php-quote">'class'</span>] = <span class="php-keyword1">array</span>(<span class="php-quote">'in'</span>,<span class="php-keyword1">array</span>(<span class="php-num">1</span>,<span class="php-num">2</span>,<span class="php-num">3</span>,<span class="php-num">4</span>,<span class="php-num">53</span>,<span class="php-num">54</span>));
</span><span id="343" class="l"><a href="#343">343: </a>
</span><span id="344" class="l"><a href="#344">344: </a>        <span class="php-comment">// 设置class 和 status条件</span>
</span><span id="345" class="l"><a href="#345">345: </a>        <span class="php-keyword1">if</span>((!<span class="php-keyword1">empty</span>(<span class="php-var">$filter</span>[<span class="php-quote">'class'</span>])) &amp;&amp; (!<span class="php-keyword1">empty</span>(<span class="php-var">$filter</span>[<span class="php-quote">'status'</span>]))){
</span><span id="346" class="l"><a href="#346">346: </a>            <span class="php-keyword1">unset</span>(<span class="php-var">$commonCondition</span>[<span class="php-quote">'status'</span>]);
</span><span id="347" class="l"><a href="#347">347: </a>            <span class="php-keyword1">unset</span>(<span class="php-var">$commonCondition</span>[<span class="php-quote">'class'</span>]);
</span><span id="348" class="l"><a href="#348">348: </a>            <span class="php-var">$commonCondition</span>[<span class="php-quote">'_string'</span>] = <span class="php-quote">'('</span>.<span class="php-var">$classCondition</span>. <span class="php-quote">') AND ('</span>.<span class="php-var">$statusCondition</span>.<span class="php-quote">')'</span>;
</span><span id="349" class="l"><a href="#349">349: </a>        }<span class="php-keyword1">elseif</span>( (<span class="php-keyword1">empty</span>(<span class="php-var">$filter</span>[<span class="php-quote">'class'</span>])) &amp;&amp; (!<span class="php-keyword1">empty</span>(<span class="php-var">$filter</span>[<span class="php-quote">'status'</span>]))){
</span><span id="350" class="l"><a href="#350">350: </a>            <span class="php-keyword1">unset</span>(<span class="php-var">$commonCondition</span>[<span class="php-quote">'status'</span>]);
</span><span id="351" class="l"><a href="#351">351: </a>            <span class="php-var">$commonCondition</span>[<span class="php-quote">'_string'</span>] =  <span class="php-var">$statusCondition</span>;
</span><span id="352" class="l"><a href="#352">352: </a>        }<span class="php-keyword1">elseif</span>( (!<span class="php-keyword1">empty</span>(<span class="php-var">$filter</span>[<span class="php-quote">'class'</span>])) &amp;&amp; (<span class="php-keyword1">empty</span>(<span class="php-var">$filter</span>[<span class="php-quote">'status'</span>])) )
</span><span id="353" class="l"><a href="#353">353: </a>        {
</span><span id="354" class="l"><a href="#354">354: </a>            <span class="php-keyword1">unset</span>(<span class="php-var">$commonCondition</span>[<span class="php-quote">'class'</span>]);
</span><span id="355" class="l"><a href="#355">355: </a>            <span class="php-var">$commonCondition</span>[<span class="php-quote">'_string'</span>] =  <span class="php-var">$classCondition</span>;
</span><span id="356" class="l"><a href="#356">356: </a>        }
</span><span id="357" class="l"><a href="#357">357: </a>
</span><span id="358" class="l"><a href="#358">358: </a>        <span class="php-comment">// 获取admin_uid </span>
</span><span id="359" class="l"><a href="#359">359: </a>        <span class="php-var">$commonCondition</span>[<span class="php-quote">'admin_uid'</span>] = getAdminUid();
</span><span id="360" class="l"><a href="#360">360: </a>
</span><span id="361" class="l"><a href="#361">361: </a>        <span class="php-comment">//拼接sql</span>
</span><span id="362" class="l"><a href="#362">362: </a>        <span class="php-var">$orderSql</span> = D(<span class="php-quote">'order'</span>)-&gt;where(<span class="php-var">$commonCondition</span>)-&gt;where(<span class="php-var">$orderMap</span>)-&gt;buildSql();
</span><span id="363" class="l"><a href="#363">363: </a>        <span class="php-keyword1">if</span>(<span class="php-keyword1">empty</span>(<span class="php-var">$commonCondition</span>[<span class="php-quote">'_string'</span>]))
</span><span id="364" class="l"><a href="#364">364: </a>            <span class="php-var">$commonCondition</span>[<span class="php-quote">'_string'</span>] = <span class="php-quote">&quot;(`sto_id` = &quot;</span>. <span class="php-var">$this</span>-&gt;sto_id  . <span class="php-quote">&quot; or `new_sto_id` =&quot;</span> .<span class="php-var">$this</span>-&gt;sto_id.<span class="php-quote">&quot;)&quot;</span>;
</span><span id="365" class="l"><a href="#365">365: </a>        <span class="php-keyword1">else</span>
</span><span id="366" class="l"><a href="#366">366: </a>            <span class="php-var">$commonCondition</span>[<span class="php-quote">'_string'</span>] .= <span class="php-quote">&quot;AND (`sto_id` = &quot;</span>. <span class="php-var">$this</span>-&gt;sto_id  . <span class="php-quote">&quot; or `new_sto_id`=&quot;</span> .<span class="php-var">$this</span>-&gt;sto_id.<span class="php-quote">&quot;)&quot;</span>;
</span><span id="367" class="l"><a href="#367">367: </a>
</span><span id="368" class="l"><a href="#368">368: </a>        <span class="php-var">$warehouseSql</span> = D(<span class="php-quote">'warehouse'</span>)-&gt;where(<span class="php-var">$commonCondition</span>)-&gt;where(<span class="php-var">$warehouseMap</span>)-&gt;buildSql();
</span><span id="369" class="l"><a href="#369">369: </a>        <span class="php-var">$unionSql</span> =<span class="php-quote">'( '</span>.<span class="php-var">$orderSql</span>.<span class="php-quote">' UNION '</span>.<span class="php-var">$warehouseSql</span>.<span class="php-quote">' )'</span>;
</span><span id="370" class="l"><a href="#370">370: </a>        log_(<span class="php-quote">&quot;orderSql&quot;</span>,<span class="php-var">$orderSql</span>,<span class="php-var">$this</span>);
</span><span id="371" class="l"><a href="#371">371: </a>        log_(<span class="php-quote">&quot;warehouseSql&quot;</span>,<span class="php-var">$warehouseSql</span>,<span class="php-var">$this</span>);
</span><span id="372" class="l"><a href="#372">372: </a>        log_(<span class="php-quote">&quot;unionSql&quot;</span>,<span class="php-var">$unionSql</span>,<span class="php-var">$this</span>);
</span><span id="373" class="l"><a href="#373">373: </a>        <span class="php-comment">//计算总页数、当前页码</span>
</span><span id="374" class="l"><a href="#374">374: </a>        <span class="php-keyword1">if</span>(!<span class="php-keyword1">empty</span>(<span class="php-var">$data</span>[<span class="php-quote">'page'</span>]) &amp;&amp; !<span class="php-keyword1">empty</span>(<span class="php-var">$data</span>[<span class="php-quote">'pline'</span>]))<span class="php-comment">//没有传代表是QueryModel::skuChart()在调用，不分页</span>
</span><span id="375" class="l"><a href="#375">375: </a>        {
</span><span id="376" class="l"><a href="#376">376: </a>            <span class="php-var">$reData</span>[<span class="php-quote">'total_page'</span>] = <span class="php-keyword2">ceil</span>(<span class="php-var">$this</span>-&gt;table(<span class="php-var">$unionSql</span>.<span class="php-quote">' tmp_union'</span>)-&gt;<span class="php-keyword2">count</span>()/<span class="php-var">$data</span>[<span class="php-quote">'pline'</span>]) ;
</span><span id="377" class="l"><a href="#377">377: </a>            <span class="php-keyword1">if</span>(<span class="php-var">$reData</span>[<span class="php-quote">'total_page'</span>] == <span class="php-num">0</span>)
</span><span id="378" class="l"><a href="#378">378: </a>                <span class="php-var">$reData</span>[<span class="php-quote">'total_page'</span>] = <span class="php-num">1</span>;
</span><span id="379" class="l"><a href="#379">379: </a>            <span class="php-keyword1">if</span>(<span class="php-var">$this</span>-&gt;page &gt; <span class="php-var">$reData</span>[<span class="php-quote">'total_page'</span>])
</span><span id="380" class="l"><a href="#380">380: </a>                <span class="php-var">$this</span>-&gt;page = <span class="php-num">1</span>;
</span><span id="381" class="l"><a href="#381">381: </a>            <span class="php-var">$reData</span>[<span class="php-quote">'now_page'</span>] = <span class="php-var">$this</span>-&gt;page;
</span><span id="382" class="l"><a href="#382">382: </a>            <span class="php-var">$reData</span>[<span class="php-quote">'data'</span>] = <span class="php-var">$this</span>
</span><span id="383" class="l"><a href="#383">383: </a>                -&gt;table(<span class="php-var">$unionSql</span>.<span class="php-quote">' tmp_union'</span>)
</span><span id="384" class="l"><a href="#384">384: </a>                -&gt;field(<span class="php-var">$this</span>-&gt;field)
</span><span id="385" class="l"><a href="#385">385: </a>                -&gt;order(<span class="php-quote">'reg_time desc'</span>)
</span><span id="386" class="l"><a href="#386">386: </a>                -&gt;page(<span class="php-var">$reData</span>[<span class="php-quote">'now_page'</span>],<span class="php-var">$this</span>-&gt;pline)
</span><span id="387" class="l"><a href="#387">387: </a>                -&gt;select();
</span><span id="388" class="l"><a href="#388">388: </a>        }<span class="php-keyword1">else</span>
</span><span id="389" class="l"><a href="#389">389: </a>        {
</span><span id="390" class="l"><a href="#390">390: </a>            <span class="php-var">$reData</span>[<span class="php-quote">'data'</span>] = <span class="php-var">$this</span>
</span><span id="391" class="l"><a href="#391">391: </a>                -&gt;table(<span class="php-var">$unionSql</span>.<span class="php-quote">' tmp_union'</span>)
</span><span id="392" class="l"><a href="#392">392: </a>                -&gt;field(<span class="php-var">$this</span>-&gt;field)
</span><span id="393" class="l"><a href="#393">393: </a>                -&gt;order(<span class="php-quote">'reg_time desc'</span>)
</span><span id="394" class="l"><a href="#394">394: </a>                -&gt;select();
</span><span id="395" class="l"><a href="#395">395: </a>        }
</span><span id="396" class="l"><a href="#396">396: </a>
</span><span id="397" class="l"><a href="#397">397: </a>        <span class="php-keyword1">if</span>(<span class="php-var">$reData</span>[<span class="php-quote">'data'</span>] === <span class="php-keyword1">false</span>){
</span><span id="398" class="l"><a href="#398">398: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14000</span>);
</span><span id="399" class="l"><a href="#399">399: </a>        }
</span><span id="400" class="l"><a href="#400">400: </a>
</span><span id="401" class="l"><a href="#401">401: </a>        <span class="php-keyword1">foreach</span>(<span class="php-var">$reData</span>[<span class="php-quote">'data'</span>] <span class="php-keyword1">as</span> <span class="php-var">$key</span>=&gt;&amp;<span class="php-var">$value</span>)
</span><span id="402" class="l"><a href="#402">402: </a>        {
</span><span id="403" class="l"><a href="#403">403: </a>            <span class="php-comment">//将购物车内容转换为json</span>
</span><span id="404" class="l"><a href="#404">404: </a>            <span class="php-keyword1">if</span>(!<span class="php-keyword1">empty</span>(<span class="php-var">$value</span>[<span class="php-quote">'cart'</span>]))
</span><span id="405" class="l"><a href="#405">405: </a>                {
</span><span id="406" class="l"><a href="#406">406: </a>                    <span class="php-var">$tmpSerialize</span> = <span class="php-keyword1">null</span>;
</span><span id="407" class="l"><a href="#407">407: </a>                    <span class="php-var">$tmpSerialize</span> = <span class="php-keyword2">unserialize</span>(<span class="php-var">$value</span>[<span class="php-quote">'cart'</span>]);
</span><span id="408" class="l"><a href="#408">408: </a>                    <span class="php-keyword1">if</span>(<span class="php-var">$tmpSerialize</span> === <span class="php-keyword1">false</span>){
</span><span id="409" class="l"><a href="#409">409: </a>                        <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> \XYException(__METHOD__,-<span class="php-num">14550</span>);
</span><span id="410" class="l"><a href="#410">410: </a>                    }
</span><span id="411" class="l"><a href="#411">411: </a>                    <span class="php-var">$value</span>[<span class="php-quote">'cart'</span>] = <span class="php-var">$tmpSerialize</span>;
</span><span id="412" class="l"><a href="#412">412: </a>                    <span class="php-comment">//删除cart中非当前sku_id的数据</span>
</span><span id="413" class="l"><a href="#413">413: </a>                    <span class="php-keyword1">foreach</span>(<span class="php-var">$value</span>[<span class="php-quote">'cart'</span>] <span class="php-keyword1">as</span> <span class="php-var">$k1</span>=&gt;<span class="php-var">$v1</span>)
</span><span id="414" class="l"><a href="#414">414: </a>                    {
</span><span id="415" class="l"><a href="#415">415: </a>                        <span class="php-keyword1">if</span>(<span class="php-var">$v1</span>[<span class="php-quote">'sku_id'</span>] !=<span class="php-var">$this</span>-&gt;sku_id)
</span><span id="416" class="l"><a href="#416">416: </a>                            {
</span><span id="417" class="l"><a href="#417">417: </a>                                <span class="php-keyword1">unset</span>(<span class="php-var">$value</span>[<span class="php-quote">'cart'</span>][<span class="php-var">$k1</span>]);
</span><span id="418" class="l"><a href="#418">418: </a>                            }
</span><span id="419" class="l"><a href="#419">419: </a>                    }
</span><span id="420" class="l"><a href="#420">420: </a>                }
</span><span id="421" class="l"><a href="#421">421: </a>        }
</span><span id="422" class="l"><a href="#422">422: </a>
</span><span id="423" class="l"><a href="#423">423: </a>        <span class="php-comment">//将返回数据的cart下标都改为0</span>
</span><span id="424" class="l"><a href="#424">424: </a>        <span class="php-keyword1">foreach</span>(<span class="php-var">$reData</span>[<span class="php-quote">'data'</span>] <span class="php-keyword1">as</span> <span class="php-var">$k</span>=&gt;&amp;<span class="php-var">$v</span>)
</span><span id="425" class="l"><a href="#425">425: </a>        {
</span><span id="426" class="l"><a href="#426">426: </a>            <span class="php-keyword1">foreach</span>(<span class="php-var">$v</span>[<span class="php-quote">'cart'</span>] <span class="php-keyword1">as</span> <span class="php-var">$k1</span>=&gt;<span class="php-var">$v1</span>)<span class="php-comment">//因为得不到v['cart']里唯一的一个的值的下标，所以只能foreach</span>
</span><span id="427" class="l"><a href="#427">427: </a>            {
</span><span id="428" class="l"><a href="#428">428: </a>                <span class="php-keyword1">if</span>(<span class="php-var">$k1</span> != <span class="php-num">0</span>)
</span><span id="429" class="l"><a href="#429">429: </a>                {
</span><span id="430" class="l"><a href="#430">430: </a>                    <span class="php-var">$v</span>[<span class="php-quote">'cart'</span>][<span class="php-num">0</span>] = <span class="php-var">$v</span>[<span class="php-quote">'cart'</span>][<span class="php-var">$k1</span>];
</span><span id="431" class="l"><a href="#431">431: </a>                    <span class="php-keyword1">unset</span>(<span class="php-var">$v</span>[<span class="php-quote">'cart'</span>][<span class="php-var">$k1</span>]);
</span><span id="432" class="l"><a href="#432">432: </a>                }
</span><span id="433" class="l"><a href="#433">433: </a>                <span class="php-keyword1">if</span>(<span class="php-var">$v</span>[<span class="php-quote">'wid'</span>] != <span class="php-num">0</span> &amp;&amp; <span class="php-var">$v</span>[<span class="php-quote">'sto_id'</span>] == <span class="php-var">$this</span>-&gt;sto_id )
</span><span id="434" class="l"><a href="#434">434: </a>                {
</span><span id="435" class="l"><a href="#435">435: </a>                    <span class="php-var">$v</span>[<span class="php-quote">'cart'</span>][<span class="php-num">0</span>][<span class="php-quote">'quantity'</span>] = <span class="php-num">0</span> - <span class="php-var">$v</span>[<span class="php-quote">'cart'</span>][<span class="php-num">0</span>][<span class="php-quote">'quantity'</span>]; <span class="php-comment">//调出仓库数量改为负数</span>
</span><span id="436" class="l"><a href="#436">436: </a>                }
</span><span id="437" class="l"><a href="#437">437: </a>            }
</span><span id="438" class="l"><a href="#438">438: </a>        }
</span><span id="439" class="l"><a href="#439">439: </a>        <span class="php-keyword1">return</span> <span class="php-var">$reData</span>;
</span><span id="440" class="l"><a href="#440">440: </a>    }
</span><span id="441" class="l"><a href="#441">441: </a> 
</span><span id="442" class="l"><a href="#442">442: </a>}
</span><span id="443" class="l"><a href="#443">443: </a>
</span><span id="444" class="l"><a href="#444">444: </a></span></code></pre>

	<div id="footer">
		XY Server API alpha API documentation generated by <a href="http://apigen.org">ApiGen</a>
	</div>
</div>
</div>
<script src="resources/combined.js?e1238c180c0ec4879c106550549125735c31011b"></script>
<script src="elementlist.js?65b96360bff0d94f47f8799f2472e5eeb7655dd9"></script>
</body>
</html>
